insert overwrite table jms_dws.dws_all_operation_cnt_day_sum_dt partition(dt='{{ execution_date | cst_ds }}')
   select
      network_code
     ,network_name
     ,sum(input_times)
     ,sum(send_times)
     ,sum(arrival_times)
     ,sum(deliver_times)
     ,sum(sign_times)
     ,provider_desc
     ,city_desc
     ,area_desc
     ,agent_code
     ,agent_name
     ,franchisee_code
     ,franchisee_name
   from jms_dws.dws_all_operation_cnt_hour_sum_dt
     where dt = '{{ execution_date | cst_ds }}'
     group by
        network_code
       ,network_name
       ,provider_desc
       ,city_desc
       ,area_desc
       ,agent_code
       ,agent_name
       ,franchisee_code
       ,franchisee_name
           distribute by 1;